OpenEdge Data Management:<br />Database Administration DBMAN utility

Starts, stops, or queries a database. Before you can use the DBMAN command-line utility, you must use the Progress Explorer Database Configuration Tool to create the database configuration and store it in the conmgr.properties file.

Syntax


dbman [ -host `host-name` -port `port-number` \| `service-name`-user `user-name` ] -database `db-name` [ -config `config-name` -start \| -stop \| -query ]

Parameters

Specifies the name of the database you want to start. It must match the name of a database in the conmgr.properties file.

Specifies the name of the configuration with which you want to start the database.

Identifies the host machine where the AdminServer is running. The default is the local host. If your AdminServer is running on a remote host, you must use the -host host-name parameter to identify the host where the remote AdminServer is running.

Identifies the port that the AdminServer is listening on. If your AdminServer is running on a remote host, you must use the -port port-number parameter to identify the port on which the remote AdminServer is listening. The default port number is 20931.

If your AdminServer is running on a remote host, you must use the -user user-name parameter to supply a valid user name for that host. You will be prompted for the password.

Notes

When you specify a user name with the -user parameter, Windows supports three different formats:

A user name as a simple text string, such as “mary,” implies a local user whose user account is defined on the local server machine, which is the same machine that runs the AdminServer.

A user name as an explicit local user name, in which the user account is defined on the same machine that runs the AdminServer, except the user name explicitly references the local machine domain, for example “\mary”.

A user name as a user account on a specific Windows domain. The general format is Domain\User, in which the User is a valid user account defined within the domain and the Domain is any valid Windows server, including the one where the AdminServer is running.

Do not edit the conmgr.properties file directly. Instead, use the Progress Explorer Database Configuration Tool.

DBMAN supports the use of internationalization startup parameters such as, -cpinternal codepage and -cpstream codepage. See Chapter 18, "Database Startup Parameters," for a description of each database-related internationalization startup parameter.

The conmgr.properties file stores the database, configuration, and server group properties, for example:

# # Connection Manager Properties File # %% Properties File %% version 1.1 %% Oct 31, 2005 1:59:37 PM # # The following are optional configuration properties and their default # values. The legacy option, if applicable, is listed after the second comment. # Property values set at this level become the default values for all # configuration subgroups. # [configuration] # afterimagebuffers=5 # -aibufs # afterimageprocess=false # n/a # afterimagestall=true # -aistall # asynchronouspagewriters=1 # n/a # beforeimagebufferedwrites=false # -r # beforeimagebuffers=5 # -bibufs # beforeimageclusterage=60 # -G # beforeimagedelaywrites=3 # -Mf # beforeimageprocess=true # n/a # blocksindatabasebuffers=0 # -B (calculated as 8*(-n)) # casetablename=basic # -cpcase # collationtable=basic # -cpcoll # conversionmap=convmap.cp # -convmap # crashprotection=true # -i # databasecodepage=basic # -cpdb # directio=false # -directio # hashtableentries=0 # -hash (calculated as (-B)/4) # internalcodepage=iso8859-1 # -cpinternal # locktableentries=10000 # -L # logcharacterset=iso8859-1 # -cplog # maxservers=4 # -Mn # maxusers=20 # -n # nap=1 # -nap # napmax=1 # -napmax # pagewritermaxbuffers=25 # -pwwmax # pagewriterqueuedelay=100 # -pwqdelay # pagewriterqueuemin=1 # -pwqmin # pagewriterscan=1 # -pwscan # pagewriterscandelay=1 # -pwsdelay # semaphoresets=1 # -semsets # sharedmemoryoverflowsize=0 # -Mxs # spinlockretries=0 # -spin # sqlyearoffset=1950 # -yy # watchdogprocess=true # n/a
# The following are optional database # properties and their default values. # Property values set at this level become # the default values for all database # subgroups. # [database] # autostart=false # autostart the defaultconfiguration? # databasename=demo # absolute or relative path + database name # The following are optional server group # properties and their default values. # The legacy option, if applicable, is listed after the second comment. # Property values set at this level become the default values for all # servergroup subgroups. # [servergroup] # host=localhost # -H # initialservers=0 # n/a # maxclientsperserver=0 # -Ma (calculated value) # maxdynamicport=5000 # -maxport (5000 for NT; 2000 for UNIX) # messagebuffersize=350 # -Mm (4gl only) # minclientsperserver=1 # -Mi # mindynamicport=3000 # -minport (3000 for NT; 1025 for UNIX) # networkclientsupport=true # false for self-service # numberofservers=0 # -Mpb # port=0 # -S ; Must be non-zero # # when networkclientsupport=true # prosqltrc=nnnnnnnnnnn # turn on various levels of SQL tracing # reportinginterval=1 # -rpint (4gl only) # serverexe=<4gl server location> # _mprosrv (4gl only) # type=both # n/a [configuration.sports2000.defaultconfiguration] database=sports2000 displayname=defaultConfiguration servergroups=sports2000.defaultconfiguration.defaultservergroup [database.sports2000] autostart=true configurations=sports2000.defaultconfiguration databasename=d:\work\database\101a\AuditEnabled\sports2000 defaultconfiguration=sports2000.defaultconfiguration displayname=sports2000 [environment] [servergroup.sports2000.defaultconfiguration.defaultservergroup] configuration=sports2000.defaultconfiguration displayname=defaultServerGroup port=14000

# 
# Connection Manager Properties File 
# 
%% Properties File 
%% version 1.1 
%% Oct 31, 2005 1:59:37 PM 
# 
# The following are optional configuration properties and their default 
# values. The legacy option, if applicable, is listed after the second comment. 
# Property values set at this level become the default values for all  
# configuration subgroups. 
# 
[configuration] 
#    afterimagebuffers=5             # -aibufs 
#    afterimageprocess=false         # n/a  
#    afterimagestall=true            # -aistall 
#    asynchronouspagewriters=1       # n/a 
#    beforeimagebufferedwrites=false # -r 
#    beforeimagebuffers=5            # -bibufs 
#    beforeimageclusterage=60        # -G 
#    beforeimagedelaywrites=3        # -Mf 
#    beforeimageprocess=true         # n/a 
#    blocksindatabasebuffers=0       # -B (calculated as 8*(-n)) 
#    casetablename=basic             # -cpcase 
#    collationtable=basic            # -cpcoll 
#    conversionmap=convmap.cp        # -convmap 
#    crashprotection=true            # -i 
#    databasecodepage=basic          # -cpdb 
#    directio=false                  # -directio 
#    hashtableentries=0              # -hash (calculated as (-B)/4) 
#    internalcodepage=iso8859-1      # -cpinternal 
#    locktableentries=10000          # -L 
#    logcharacterset=iso8859-1       # -cplog 
#    maxservers=4                    # -Mn 
#    maxusers=20                     # -n 
#    nap=1                           # -nap 
#    napmax=1                        # -napmax 
#    pagewritermaxbuffers=25         # -pwwmax 
#    pagewriterqueuedelay=100        # -pwqdelay 
#    pagewriterqueuemin=1            # -pwqmin 
#    pagewriterscan=1                # -pwscan 
#    pagewriterscandelay=1           # -pwsdelay 
#    semaphoresets=1                 # -semsets 
#    sharedmemoryoverflowsize=0      # -Mxs 
#    spinlockretries=0               # -spin 
#    sqlyearoffset=1950              # -yy 
#    watchdogprocess=true            # n/a

# The following are optional database 
# properties and their default values. 
# Property values set at this level become 
# the default values for all database 
# subgroups. 
# 
[database] 
#    autostart=false                 # autostart the defaultconfiguration? 
#    databasename=demo               # absolute or relative path + database name 
# The following are optional server group  
# properties and their default values. 
# The legacy option, if applicable, is listed after the second comment. 
# Property values set at this level become the default values for all  
# servergroup subgroups. 
# 
[servergroup] 
#    host=localhost                  # -H 
#    initialservers=0                # n/a 
#    maxclientsperserver=0           # -Ma (calculated value) 
#    maxdynamicport=5000             # -maxport (5000 for NT; 2000 for UNIX) 
#    messagebuffersize=350           # -Mm (4gl only) 
#    minclientsperserver=1           # -Mi 
#    mindynamicport=3000             # -minport (3000 for NT; 1025 for UNIX) 
#    networkclientsupport=true       # false for self-service 
#    numberofservers=0               # -Mpb 
#    port=0                          # -S ; Must be non-zero 
#                                    # when networkclientsupport=true 
#    prosqltrc=nnnnnnnnnnn           # turn on various levels of SQL tracing 
#    reportinginterval=1             # -rpint (4gl only) 
#    serverexe=<4gl server location> # _mprosrv (4gl only) 
#    type=both                       # n/a 
[configuration.sports2000.defaultconfiguration] 
    database=sports2000 
    displayname=defaultConfiguration 
    servergroups=sports2000.defaultconfiguration.defaultservergroup 
[database.sports2000] 
    autostart=true 
    configurations=sports2000.defaultconfiguration 
    databasename=d:\work\database\101a\AuditEnabled\sports2000 
    defaultconfiguration=sports2000.defaultconfiguration 
    displayname=sports2000 
[environment] 
[servergroup.sports2000.defaultconfiguration.defaultservergroup] 
    configuration=sports2000.defaultconfiguration 
    displayname=defaultServerGroup 
    port=14000